LC - SQLite Test

Well, LC 8 dp16 seems to connect to SQLite databases (i.e. you get a valid database ID) even when a relative (no absolute) path is given, but refuses then to query this database. No problem with absolute paths.

EXPECTED RESULT: Database access should work with absolute paths as well as with relative paths. Given these are correct.

OBSERVED RESULT: LC 8dp16 connects seemingly correct with a relative path, returning a database ID. But subsequent queries fail with "No such table".
LC 6.7.10 works correctly with both kinds of paths.

How to reproduce:

1. Put "lcdb_tester.livecode" and "db_test.sqlite" to wherever you like. Together.

2. Start "lcdb_tester.livecode" in the IDE, and hit "Connect". You'll get a connection ID.

3. Hit "Query". Depending of the version used you get either a correct result (6.7.10) or an error (8 dp16).

4. Close the connection.

5. Use the button right of the database name to enter a absolute path. (Cancelling the file dialog will restore the default path)

6. Try again, now even LC 8 works.


More options:

a. You can try this with the valid SQLite parameters.

b. You can change the query. (it even accepts simple action queries, avoid periods!)

c. Should you have smashed your database, you can always "Rebuild table". Be careful to have an open connection for this!

Have fun!

Axel, "axwald" in the LC forums

PS: tested on Win 7-64 pro and Linux CentOS 7-64
PPS: any stuff is under GPL V3